Seward County Community College/Area Technical School
Course Syllabus

1. TITLE OF COURSE: - CS1603 - Microcomputer Software Suites
2. COURSE DESCRIPTION: Three credit hours lecture. This course is designed to provide the student with an overview of microcomputer applications in Microsoft Windows, Microsoft Office, Word, Excel, Access, PowerPoint and Outlook. The students will be challenged to create and integrate the applications of Microsoft Office. This course will utilize the projects approach to learning. Prerequisite: OT 1113 Basic Keyboarding or equivalent. For each unit of credit, a minimum of three hours per week with one of the hours for class and two hours for studying/preparation outside of class is expected.
3. PROGRAM AND/OR DEPARTMENT MISSION STATEMENT: The CIS Program will provide superior learning opportunities in the area of information technology, utilizing state-of-the-art technology, for both CIS majors and non CIS majors to enable all students to achieve their career and/or educational goals.
4. TEXTBOOK AND MATERIALS: TEXTBOOK AND MATERIALS: Microsoft Office 2013: Illustrated, First Course.  Beskeen, Cram, Duffy, Friedrichsen, Reding.  Cengage Learning, 2014.
5. SCCC/ATS OUTCOMES: Upon completion of the course the student should be able to:
   • Read with comprehension, be critical of what they read, and apply knowledge gained from their reading to broader issues of the day.
   • Communicate their ideas clearly and proficiently in writing and speaking, appropriately adjusting content and arrangement for varying audiences, purposes, and situations.
   • Solve problems using a variety of techniques and technologies.
   • Think critically by gathering facts, generating insights, analyzing data, and evaluating information.
   • Utilize current technology relevant to their respective disciplines.
   • Effectively exhibit workplace skills to include respect for others, teamwork competence, attendance/punctuality, decision making, conflict resolution, truthfulness/honesty, positive attitude, judgment, responsibility.
6. COURSE OUTCOMES: Upon completion of the Microcomputer Software Suites course with 80% or higher mastery of course competencies, the student should be able to:
   • Demonstrate a proficiency in Windows.
   • Demonstrate a proficiency in the basics of Word, Excel, Access, and PowerPoint.
   • Demonstrate proficiency in integrating the Microsoft Office applications.
   • Utilize course information to prepare for proficiency certification exams.
7. COURSE COMPETENCIES:
   • Word Processing
     • Create and edit a document
     • Create a research paper
     • Create a resume using a Wizard
     • Create a cover letter with a table
     • Create web pages using Word
   • Spreadsheets
     • Create a worksheet and embedded chart
     • Formulas, functions, formatting, and web queries
     • What-If Analysis, charting, and working with large worksheets
     • Create static and dynamic web pages using Excel
   • Database
     • Create a database using design and datasheet views
     • Querying a database using the select query window
     • Maintaining a database using the design and update features of Access
     • Publishing to the Internet using data access pages
   • Presentations
     • Using a design template and text slide layout to create a presentation
     • Use the outline tab and clip art to create a slide show
     • Customize graphical bullets using slide master
     • Create a presentation on the web using PowerPoint
   • Integration Office XP Applications and the World Wide Web
8. COURSE OUTLINE:
   • Word
     • Document creation
     • Web page creation
   • Excel
     • Worksheet creation
     • Formulas, functions, formatting, and web queries
     • What-If Analysis, charting, and working with large worksheets
     • Static and dynamic web pages using Excel
   • Access
     • Database creation with design and datasheet views
     • Database queries using the select query window
     • Maintain a database using the design and update features of Access
     • Publish to the Internet using data access pages
   • PowerPoint
     • Create a presentation
     • Create a slide show
     • Customize slide master
     • Create a presentation on the web
   • Integration Microsoft Office Applications
9. INSTRUCTIONAL METHODS:
   • Class discussions and demonstrations using the MS Office Course Presenter and assigned class projects.
   • Projects
   • Related readings and reports from printed or web sources.
10. INSTRUCTIONAL AND RESOURCE MATERIALS:
    • Microsoft Office Teaching Tools
    • Microsoft Office Course Presenter
11. METHODS OF ASSESSMENT:
    • Hands on project assignments
    • Quizzes
    • Examinations
    • Measurement of SCCC/ATS Outcomes will be assessed through project assignments, examinations, attendance, and promptness in meeting assigned due dates.
12. ADA STATEMENT
    • If you believe that you are entitled to special accommodations under the Americans with Disabilities Act, please contact the Dean of Student Services at 620-417-1016 or visit the office located in the Hobble Academic Building.  
        
      
    Revised 09/14